From 71e1ce1a407fec7d9da043aabd0ddb8ed141b546 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Thu, 13 Aug 2026 15:43:27 +0000 Subject: [PATCH] Check COMM_MEMBS against birthdate only when necessary --- db/schemas/lib/triggers/create/biography_data.m4 | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/db/schemas/lib/triggers/create/biography_data.m4 b/db/schemas/lib/triggers/create/biography_data.m4 index fb62f77..b99c0f3 100644 --- a/db/schemas/lib/triggers/create/biography_data.m4 +++ b/db/schemas/lib/triggers/create/biography_data.m4 @@ -324,7 +324,7 @@ CREATE OR REPLACE FUNCTION biography_data_func () -- An individual may not be placed in a community before their birth date. IF TG_OP = 'UPDATE' - AND ((NEW.birthdate <> OLD.birthdate) + AND ((NEW.birthdate > OLD.birthdate) OR (NEW.birthcomm <> OLD.birthcomm)) THEN DECLARE commmid comm_membs.commmid%TYPE; -- 2.34.1